For each item added to the report, you can control which columns are added to the table and the display of the table contents.

1. Right-click on the item in the Report Builder panel and then select General > Format from the pop-up menu. The Customize Table dialog opens.

   The table shows the report table columns and their properties.

2. To hide a column from the table, uncheck the Include option for that item.
3. To change the display of the table cell, select the Width, Alignment options.
4. To change the numerical display, change the Decimal Places and optionally select the Eng. Format.
   Note: These options are inactive for items with text content for tables which have a filter applied.
5. Click OK.

1. On the Reports ribbon tab, select the Filter tool in the Setup group.
   
   The Report Filters dialog opens.
2. To filter load cases used in the report:
   1. Select the Load Cases tab.
   2. Select the load cases to include in the report and then add those to the Selected column.
      Tip: Use the Search field to search for load cases by title.
3. To filter modes used in the report:
   1. Select the Modes tab.
   2. Select the modes to include in the report and then add those to the Selected column.
4. To filter the steel design results:
   1. Select the Steel Design tab.
   2. For both design check and selection operations, you narrow the report to include:
      • all items
      • no items
      • only the first parameter block where a member is included
      • only the last parameter block where a member is included
   3. You can also select to limit the results to summary only.
   4. You can also select to limit the results to only failed members.
5. To filter ranges of other data:
   1. Select the Ranges tab.
   2. You can select to narrow the report to:
      • Objects in a named view
      • Objects in a named group
      • Member property
      • Ranges of node numbers or member, pate, and solid numbers
      Note: Global filters on range will not apply to tables with custom filters.
6. Click OK.

You can add a custom SQL query to a report item in order to further filter what content is added to the report.

1. Right-click on the item in the Report Builder panel and then select Customization > Add from the pop-up menu. The Query Builder dialog opens.
2. In the center panel, select the columns to include in the custom table. By default, the wild card (i.e., All Columns) is selected.
   Tip: Some data tables include a internal-use column named "RowId". This column is hidden from report output and it's selection status has no effect on the report contents displayed.
3. Add a filter for the data:
   1. Click Filter. The Filter Editor dialog opens.
   2. Hovering over the initial empty operator (labeled "And"), click the + tool. A query condition is added.
   3. Click the orange field to select from drop-down list of the table columns on which to filter.
   4. Click the operator (default is "=") to select from a list of filter operators.
      Tip: When using "double" (double-precision floating-point decimal) data fields, it is recommended to use the "is between" or "is not between" operators instead of "equals" or "does not equal" due to tolerances on the table data versus the rounded values displayed. For integers or string fields, "equals" or "does not equal" work best.
   5. Click the green field and type the value for the filter.
   6. Repeat steps 3a through 3e to include additional query conditions.

   Click the "X" to the right of a condition to remove it from the query.

4. Click the "And" operator to change the filter set method. You can make the set method "and", "or", "not and", or "not or".
5. Click OK.
6. Click Preview Results to display the results of the query (up to the first 1,000 rows).
7. Click OK.